[dbo].[BAEOrderCategoryUpdate]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@OrderCategoryID	int	4
@Title	varchar(64)	64
@Description	varchar(1024)	1024
@Active	bit	1
@Header	varchar(512)	512
@Footer	varchar(512)	512
@Image	varchar(1024)	1024
@SecurityKey	varchar(64)	64

SQL Script

create procedure [dbo].[BAEOrderCategoryUpdate] @OrderCategoryID as
int,
    @Title AS varchar(64),
    @Description AS varchar(1024),
    @Active AS bit,
    @Header AS varchar(512),
    @Footer AS varchar(512),
    @Image AS varchar(1024),
    @SecurityKey AS varchar(64)
AS
    UPDATE OrderCategory
    SET
    Title =             @Title,
    Description =         @Description,
    Active =             @Active,
    Header =             @Header,
    Footer =             @Footer,
    Image =             @Image,
    SecurityKey =         @SecurityKey

    WHERE OrderCategoryID = @OrderCategoryID;

GO